select distinct substring(name,1,1) from stamps ,np_master where year(stamps.issue_date)=2000 and month(issue_date)=12 and dayofmonth(stamps.issue_date)=31 and np_master.np_code=stamps.np_code and np_master.np='R' and stamps.serial_no='1978' order by substring(name,1,1)
IndianPost
Issue Date >> year >> 2000 >> month >> December >> day >> 31 >> Currency >> R >> Serial Number >> 1978 >> Alpha >> G >>